package com.example.sxmall.dao.mapper;

import com.example.sxmall.dao.pojo.Shoes_inquirys;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

@Mapper
public interface Shoes_inquirysMapper {
    /**
     * 查看资讯列表
     * @return
     */
    public List<Shoes_inquirys> listShoes_inquirys();

    /**
     * 根据ID查询资讯
     * @param sqid
     * @return
     */
    public Shoes_inquirys findShoes_inquirysById(@Param("sqid") Integer sqid);

    /**
     * 根据鞋子ID查询
     * @param sq_sid
     * @return
     */
    public List<Shoes_inquirys> findShoes_inquirysBySid(@Param("sq_sid") Integer sq_sid);

    /**
     * 根据鞋子ID和用户ID查询
     * @param sq_sid
     * @param sq_uid
     * @return
     */
    public List<Shoes_inquirys> findShoes_inquirysBySidAndUid(@Param("sq_sid") Integer sq_sid,@Param("sq_sid") Integer sq_uid);

    /**
     * 添加
     * @param shoes_inquirys
     * @return
     */
    public int insertShoes_inquirys(@Param("shoes_inquirys") Shoes_inquirys shoes_inquirys);

    /**
     * 删除
     * @param sqid
     * @return
     */
    public int deleteShoes_inquirys(@Param("sqid") int sqid);

    /**
     * 动态修改
     * @param shoes_inquirys
     * @return
     */
    public int updateShoes_inquirys(@Param("shoes_inquirys") Shoes_inquirys shoes_inquirys);
}
